package yl.hs.bmipfull.daos.salemanage;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import yl.hs.bmipfull.daos.BaseDao;
import yl.hs.bmipfull.pojo.salemanage.ProductPricesEntity;
import yl.hs.bmipfull.pojo.salemanage.SaleContractAdditionalMoneyEntity;

import java.util.List;

/**
 * 作用:   <br/>
 * 创建时间: 2023-02-14 11:20 <br/>
 *
 * @author 吴高丰
 */
@Repository
public interface ISaleContractAdditionalMoneyDao extends BaseDao<SaleContractAdditionalMoneyEntity> {
    @Select("select * from sale_contract_additional_money where contractSn=#{contractSn}")
    List<SaleContractAdditionalMoneyEntity> queryAdditional(String contractSn);
    @Delete("delete from sale_contract_additional_money where contractSn=#{contractSn}")
    Integer deleteByContractSn(String contractSn);
    @Insert("INSERT INTO sale_contract_additional_money (contractSn, additionalItems, money) VALUES (#{contractSn}, #{additionalItems}, #{money})")
    Integer insertSaleContractAdditionalMoney(SaleContractAdditionalMoneyEntity entity);
}
